package com.ciwong.epaper.modules.reciteWords.dbreciteword;

public class DBColumns {

    public static final String _ID = "_id";//数据库唯一标识
    public static final String EXPLANATION_ID = "dId";//单词释义，单词的唯一标识
    public static final String WORD_ID = "wId";//单词id
    public static final String WORDS = "words";//单词
    public static final String WORD_FILE = "wordFile";//单词读音音频文件
    public static final String WORD_TYPE = "wordType";// 是否拓展单词 0==否 1==是
    public static final String SYMBOL = "symbol";//音标
    public static final String SYLLABLE = "syllable";//音节
    public static final String PRETATIONS = "pretations";//释义
    public static final String SENTENCE = "sentences";//课文例句
    public static final String SENTENCE_FILE = "sentFile";//例句问卷音频文件
    public static final String WORD_PIC = "wordPic";//实例图片
    public static final String COLOR = "color";//音标


    public static String getCreateTableWordDetailString(String tableName) {

        String CREATE_TABLE = "create table if not exists " + tableName + " ("
                + DBColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + DBColumns.EXPLANATION_ID + " TEXT, "
                + DBColumns.WORD_ID + " TEXT, "
                + DBColumns.WORDS + " TEXT, "
                + DBColumns.WORD_FILE + " TEXT, "
                + DBColumns.WORD_TYPE + " INTEGER NOT NULL, "
                + DBColumns.SYMBOL + " TEXT, "
                + DBColumns.SYLLABLE + " TEXT, "
                + DBColumns.PRETATIONS + " TEXT, "
                + DBColumns.SENTENCE + " TEXT, "
                + DBColumns.SENTENCE_FILE + " TEXT, "
                + DBColumns.WORD_PIC + " TEXT, "
                + DBColumns.COLOR + " INTEGER NOT NULL "
                + ") ";//数据库里的表

        return CREATE_TABLE;
    }

    public static String BOOK_ID = "bookId";//作为主键
    public static String URL_HASH_CODE = "urlhashcode";

    public static String getCreateTableWordBookStateString(String tableName) {

        String CREATE_TABLE = "create table if not exists " + tableName + " ("
                + DBColumns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
                + DBColumns.BOOK_ID + " TEXT, "
                + DBColumns.URL_HASH_CODE + " TEXT"
                + ") ";//数据库里的表

        return CREATE_TABLE;
    }


}
